Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 2409 |
| Missing cells | 1071 |
| Missing cells (%) | 2.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 437.6 KiB |
| Average record size in memory | 186.0 B |
Variable types
| NUM | 13 |
|---|---|
| CAT | 5 |
Reproduction
| Analysis started | 2021-12-13 21:03:30.093032 |
|---|---|
| Analysis finished | 2021-12-13 21:03:49.253333 |
| Duration | 19.16 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
name has a high cardinality: 2304 distinct values | High cardinality |
style has a high cardinality: 99 distinct values | High cardinality |
abv has 62 (2.6%) missing values | Missing |
ibu has 1004 (41.7%) missing values | Missing |
name is uniformly distributed | Uniform |
id has unique values | Unique |
Unnamed: 0 has unique values | Unique |
| Distinct count | 74 |
|---|---|
| Unique (%) | 3.2% |
| Missing | 62 |
| Missing (%) | 2.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.05977758841073711 |
|---|---|
| Minimum | 0.001 |
| Maximum | 0.128 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 0.001 |
|---|---|
| 5-th percentile | 0.042 |
| Q1 | 0.05 |
| median | 0.056 |
| Q3 | 0.067 |
| 95-th percentile | 0.087 |
| Maximum | 0.128 |
| Range | 0.127 |
| Interquartile range (IQR) | 0.017 |
Descriptive statistics
| Standard deviation | 0.01354311578 |
|---|---|
| Coefficient of variation (CV) | 0.2265584167 |
| Kurtosis | 1.143717428 |
| Mean | 0.05977758841 |
| Median Absolute Deviation (MAD) | 0.008 |
| Skewness | 0.9578296204 |
| Sum | 140.298 |
| Variance | 0.0001834159851 |
| Value | Count | Frequency (%) | |
| 0.05 | 214 | 8.9% | |
| 0.055 | 158 | 6.6% | |
| 0.06 | 125 | 5.2% | |
| 0.065 | 123 | 5.1% | |
| 0.052 | 107 | 4.4% | |
| 0.07 | 92 | 3.8% | |
| 0.045 | 89 | 3.7% | |
| 0.048 | 72 | 3.0% | |
| 0.058 | 66 | 2.7% | |
| 0.056 | 66 | 2.7% | |
| Other values (64) | 1235 | 51.3% |
| Value | Count | Frequency (%) | |
| 0.001 | 1 | < 0.1% | |
| 0.027 | 2 | 0.1% | |
| 0.028 | 1 | < 0.1% | |
| 0.032 | 3 | 0.1% | |
| 0.034 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.128 | 1 | < 0.1% | |
| 0.125 | 1 | < 0.1% | |
| 0.12 | 1 | < 0.1% | |
| 0.104 | 1 | < 0.1% | |
| 0.1 | 1 | < 0.1% |
brewery_id
Real number (ℝ≥0)
| Distinct count | 557 |
|---|---|
| Unique (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 231.6766293067663 |
|---|---|
| Minimum | 0 |
| Maximum | 557 |
| Zeros | 6 |
| Zeros (%) | 0.2% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11.4 |
| Q1 | 93 |
| median | 205 |
| Q3 | 366 |
| 95-th percentile | 505.6 |
| Maximum | 557 |
| Range | 557 |
| Interquartile range (IQR) | 273 |
Descriptive statistics
| Standard deviation | 157.6774235 |
|---|---|
| Coefficient of variation (CV) | 0.6805927037 |
| Kurtosis | -1.086431747 |
| Mean | 231.6766293 |
| Median Absolute Deviation (MAD) | 131 |
| Skewness | 0.3089630817 |
| Sum | 558109 |
| Variance | 24862.16989 |
| Value | Count | Frequency (%) | |
| 10 | 62 | 2.6% | |
| 25 | 38 | 1.6% | |
| 166 | 33 | 1.4% | |
| 141 | 25 | 1.0% | |
| 46 | 24 | 1.0% | |
| 80 | 23 | 1.0% | |
| 131 | 22 | 0.9% | |
| 368 | 20 | 0.8% | |
| 165 | 20 | 0.8% | |
| 107 | 19 | 0.8% | |
| Other values (547) | 2123 | 88.1% |
| Value | Count | Frequency (%) | |
| 0 | 6 | 0.2% | |
| 1 | 13 | 0.5% | |
| 2 | 5 | 0.2% | |
| 3 | 6 | 0.2% | |
| 4 | 4 | 0.2% |
| Value | Count | Frequency (%) | |
| 557 | 1 | < 0.1% | |
| 556 | 4 | 0.2% | |
| 555 | 1 | < 0.1% | |
| 554 | 1 | < 0.1% | |
| 553 | 1 | < 0.1% |
carat
Real number (ℝ≥0)
| Distinct count | 97 |
|---|---|
| Unique (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7182689912826898 |
|---|---|
| Minimum | 0.2 |
| Maximum | 1.52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 0.2 |
|---|---|
| 5-th percentile | 0.31 |
| Q1 | 0.7 |
| median | 0.72 |
| Q3 | 0.81 |
| 95-th percentile | 1 |
| Maximum | 1.52 |
| Range | 1.32 |
| Interquartile range (IQR) | 0.11 |
Descriptive statistics
| Standard deviation | 0.1919936946 |
|---|---|
| Coefficient of variation (CV) | 0.2673005475 |
| Kurtosis | 1.284624277 |
| Mean | 0.7182689913 |
| Median Absolute Deviation (MAD) | 0.06 |
| Skewness | -0.7079764546 |
| Sum | 1730.31 |
| Variance | 0.03686157878 |
| Value | Count | Frequency (%) | |
| 0.7 | 346 | 14.4% | |
| 0.71 | 278 | 11.5% | |
| 0.72 | 162 | 6.7% | |
| 0.9 | 144 | 6.0% | |
| 0.73 | 112 | 4.6% | |
| 0.32 | 110 | 4.6% | |
| 0.8 | 84 | 3.5% | |
| 0.75 | 79 | 3.3% | |
| 0.74 | 77 | 3.2% | |
| 0.77 | 68 | 2.8% | |
| Other values (87) | 949 | 39.4% |
| Value | Count | Frequency (%) | |
| 0.2 | 1 | < 0.1% | |
| 0.21 | 1 | < 0.1% | |
| 0.22 | 4 | 0.2% | |
| 0.23 | 17 | 0.7% | |
| 0.24 | 20 | 0.8% |
| Value | Count | Frequency (%) | |
| 1.52 | 2 | 0.1% | |
| 1.5 | 2 | 0.1% | |
| 1.29 | 1 | < 0.1% | |
| 1.27 | 1 | < 0.1% | |
| 1.24 | 2 | 0.1% |
clarity
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.8 KiB |
| SI1 | |
|---|---|
| VS2 | |
| VS1 | |
| SI2 | |
| VVS2 | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| SI1 | 624 | 25.9% | |
| VS2 | 556 | 23.1% | |
| VS1 | 420 | 17.4% | |
| SI2 | 408 | 16.9% | |
| VVS2 | 159 | 6.6% | |
| VVS1 | 130 | 5.4% | |
| I1 | 75 | 3.1% | |
| IF | 37 | 1.5% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.073474471 |
| Min length | 2 |
color
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.8 KiB |
| E | |
|---|---|
| F | |
| G | |
| H | |
| D | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| E | 572 | 23.7% | |
| F | 444 | 18.4% | |
| G | 428 | 17.8% | |
| H | 332 | 13.8% | |
| D | 316 | 13.1% | |
| I | 217 | 9.0% | |
| J | 100 | 4.2% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
cut
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.8 KiB |
| Ideal | |
|---|---|
| Very Good | |
| Premium | |
| Good | |
| Fair | 148 |
| Value | Count | Frequency (%) | |
| Ideal | 892 | 37.0% | |
| Very Good | 582 | 24.2% | |
| Premium | 563 | 23.4% | |
| Good | 224 | 9.3% | |
| Fair | 148 | 6.1% |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 6.279369033 |
| Min length | 4 |
depth
Real number (ℝ≥0)
| Distinct count | 122 |
|---|---|
| Unique (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.81506849315068 |
|---|---|
| Minimum | 53.0 |
| Maximum | 69.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 53 |
|---|---|
| 5-th percentile | 59.1 |
| Q1 | 61 |
| median | 61.8 |
| Q3 | 62.6 |
| 95-th percentile | 64.36 |
| Maximum | 69.5 |
| Range | 16.5 |
| Interquartile range (IQR) | 1.6 |
Descriptive statistics
| Standard deviation | 1.653753786 |
|---|---|
| Coefficient of variation (CV) | 0.02675324684 |
| Kurtosis | 3.123323885 |
| Mean | 61.81506849 |
| Median Absolute Deviation (MAD) | 0.8 |
| Skewness | 0.00675001604 |
| Sum | 148912.5 |
| Variance | 2.734901584 |
| Value | Count | Frequency (%) | |
| 61.8 | 101 | 4.2% | |
| 61.5 | 86 | 3.6% | |
| 61.6 | 84 | 3.5% | |
| 62.3 | 84 | 3.5% | |
| 61.3 | 83 | 3.4% | |
| 61.7 | 81 | 3.4% | |
| 62.1 | 80 | 3.3% | |
| 62.2 | 80 | 3.3% | |
| 61.9 | 78 | 3.2% | |
| 62.4 | 75 | 3.1% | |
| Other values (112) | 1577 | 65.5% |
| Value | Count | Frequency (%) | |
| 53 | 1 | < 0.1% | |
| 53.1 | 1 | < 0.1% | |
| 53.3 | 1 | < 0.1% | |
| 55 | 1 | < 0.1% | |
| 55.1 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 69.5 | 1 | < 0.1% | |
| 69.3 | 2 | 0.1% | |
| 68.5 | 1 | < 0.1% | |
| 68.3 | 1 | < 0.1% | |
| 68.2 | 2 | 0.1% |
| Distinct count | 107 |
|---|---|
| Unique (%) | 7.6% |
| Missing | 1004 |
| Missing (%) | 41.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.71316725978647 |
|---|---|
| Minimum | 4.0 |
| Maximum | 138.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 21 |
| median | 35 |
| Q3 | 64 |
| 95-th percentile | 92 |
| Maximum | 138 |
| Range | 134 |
| Interquartile range (IQR) | 43 |
Descriptive statistics
| Standard deviation | 25.95406591 |
|---|---|
| Coefficient of variation (CV) | 0.6076361829 |
| Kurtosis | -0.1357120402 |
| Mean | 42.71316726 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 0.7925208569 |
| Sum | 60012 |
| Variance | 673.6135373 |
| Value | Count | Frequency (%) | |
| 20 | 82 | 3.4% | |
| 35 | 60 | 2.5% | |
| 65 | 54 | 2.2% | |
| 30 | 53 | 2.2% | |
| 70 | 48 | 2.0% | |
| 18 | 46 | 1.9% | |
| 25 | 45 | 1.9% | |
| 60 | 44 | 1.8% | |
| 40 | 41 | 1.7% | |
| 15 | 40 | 1.7% | |
| Other values (97) | 892 | 37.0% | |
| (Missing) | 1004 | 41.7% |
| Value | Count | Frequency (%) | |
| 4 | 3 | 0.1% | |
| 5 | 5 | 0.2% | |
| 6 | 3 | 0.1% | |
| 7 | 7 | 0.3% | |
| 8 | 9 | 0.4% |
| Value | Count | Frequency (%) | |
| 138 | 1 | < 0.1% | |
| 135 | 1 | < 0.1% | |
| 130 | 1 | < 0.1% | |
| 126 | 1 | < 0.1% | |
| 120 | 3 | 0.1% |
| Distinct count | 2409 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1431.1112494811125 |
|---|---|
| Minimum | 1 |
| Maximum | 2692 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 135 |
| Q1 | 808 |
| median | 1454 |
| Q3 | 2076 |
| 95-th percentile | 2568.6 |
| Maximum | 2692 |
| Range | 2691 |
| Interquartile range (IQR) | 1268 |
Descriptive statistics
| Standard deviation | 752.6161934 |
|---|---|
| Coefficient of variation (CV) | 0.5258963576 |
| Kurtosis | -1.087838414 |
| Mean | 1431.111249 |
| Median Absolute Deviation (MAD) | 631 |
| Skewness | -0.1212128728 |
| Sum | 3447547 |
| Variance | 566431.1346 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 1224 | 1 | < 0.1% | |
| 1220 | 1 | < 0.1% | |
| 1218 | 1 | < 0.1% | |
| 1214 | 1 | < 0.1% | |
| 1212 | 1 | < 0.1% | |
| 1210 | 1 | < 0.1% | |
| 1208 | 1 | < 0.1% | |
| 1206 | 1 | < 0.1% | |
| 1204 | 1 | < 0.1% | |
| Other values (2399) | 2399 | 99.6% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2692 | 1 | < 0.1% | |
| 2691 | 1 | < 0.1% | |
| 2690 | 1 | < 0.1% | |
| 2689 | 1 | < 0.1% | |
| 2688 | 1 | < 0.1% |
| Distinct count | 2304 |
|---|---|
| Unique (%) | 95.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.8 KiB |
| Nonstop Hef Hop | 12 |
|---|---|
| Dale's Pale Ale | 6 |
| Oktoberfest | 6 |
| Longboard Island Lager | 4 |
| 1327 Pod's ESB | 3 |
| Other values (2299) |
| Value | Count | Frequency (%) | |
| Nonstop Hef Hop | 12 | 0.5% | |
| Dale's Pale Ale | 6 | 0.2% | |
| Oktoberfest | 6 | 0.2% | |
| Longboard Island Lager | 4 | 0.2% | |
| 1327 Pod's ESB | 3 | 0.1% | |
| Dagger Falls IPA | 3 | 0.1% | |
| Boston Lager | 3 | 0.1% | |
| Bombshell Blonde | 2 | 0.1% | |
| Halcyon Unfiltered Wheat | 2 | 0.1% | |
| #9 | 2 | 0.1% | |
| Other values (2294) | 2366 | 98.2% |
Length
| Max length | 52 |
|---|---|
| Median length | 16 |
| Mean length | 17.2988792 |
| Min length | 2 |
ounces
Real number (ℝ≥0)
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.592901618929016 |
|---|---|
| Minimum | 8.4 |
| Maximum | 32.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 8.4 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 12 |
| median | 12 |
| Q3 | 16 |
| 95-th percentile | 16 |
| Maximum | 32 |
| Range | 23.6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.352468187 |
|---|---|
| Coefficient of variation (CV) | 0.1730659319 |
| Kurtosis | 9.037233846 |
| Mean | 13.59290162 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.046132674 |
| Sum | 32745.3 |
| Variance | 5.534106569 |
| Value | Count | Frequency (%) | |
| 12 | 1524 | 63.3% | |
| 16 | 841 | 34.9% | |
| 24 | 22 | 0.9% | |
| 19.2 | 15 | 0.6% | |
| 32 | 5 | 0.2% | |
| 16.9 | 1 | < 0.1% | |
| 8.4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8.4 | 1 | < 0.1% | |
| 12 | 1524 | 63.3% | |
| 16 | 841 | 34.9% | |
| 16.9 | 1 | < 0.1% | |
| 19.2 | 15 | 0.6% |
| Value | Count | Frequency (%) | |
| 32 | 5 | 0.2% | |
| 24 | 22 | 0.9% | |
| 19.2 | 15 | 0.6% | |
| 16.9 | 1 | < 0.1% | |
| 16 | 841 | 34.9% |
price
Real number (ℝ≥0)
| Distinct count | 441 |
|---|---|
| Unique (%) | 18.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2649.266085512661 |
|---|---|
| Minimum | 326 |
| Maximum | 3179 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 326 |
|---|---|
| 5-th percentile | 556 |
| Q1 | 2812 |
| median | 2909 |
| Q3 | 3040 |
| 95-th percentile | 3152.6 |
| Maximum | 3179 |
| Range | 2853 |
| Interquartile range (IQR) | 228 |
Descriptive statistics
| Standard deviation | 811.2885808 |
|---|---|
| Coefficient of variation (CV) | 0.3062314447 |
| Kurtosis | 2.989353276 |
| Mean | 2649.266086 |
| Median Absolute Deviation (MAD) | 108 |
| Skewness | -2.19025434 |
| Sum | 6382082 |
| Variance | 658189.1613 |
| Value | Count | Frequency (%) | |
| 561 | 91 | 3.8% | |
| 554 | 34 | 1.4% | |
| 558 | 32 | 1.3% | |
| 2822 | 23 | 1.0% | |
| 557 | 21 | 0.9% | |
| 2777 | 21 | 0.9% | |
| 3084 | 19 | 0.8% | |
| 559 | 18 | 0.7% | |
| 3105 | 17 | 0.7% | |
| 3145 | 17 | 0.7% | |
| Other values (431) | 2116 | 87.8% |
| Value | Count | Frequency (%) | |
| 326 | 2 | 0.1% | |
| 327 | 1 | < 0.1% | |
| 334 | 1 | < 0.1% | |
| 335 | 1 | < 0.1% | |
| 336 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 3179 | 3 | 0.1% | |
| 3178 | 2 | 0.1% | |
| 3177 | 2 | 0.1% | |
| 3176 | 5 | 0.2% | |
| 3175 | 9 | 0.4% |
| Distinct count | 99 |
|---|---|
| Unique (%) | 4.1% |
| Missing | 5 |
| Missing (%) | 0.2% |
| Memory size | 18.8 KiB |
| American IPA | |
|---|---|
| American Pale Ale (APA) | 245 |
| American Amber / Red Ale | 133 |
| American Blonde Ale | 108 |
| American Double / Imperial IPA | 105 |
| Other values (94) |
| Value | Count | Frequency (%) | |
| American IPA | 424 | 17.6% | |
| American Pale Ale (APA) | 245 | 10.2% | |
| American Amber / Red Ale | 133 | 5.5% | |
| American Blonde Ale | 108 | 4.5% | |
| American Double / Imperial IPA | 105 | 4.4% | |
| American Pale Wheat Ale | 97 | 4.0% | |
| American Brown Ale | 70 | 2.9% | |
| American Porter | 68 | 2.8% | |
| Saison / Farmhouse Ale | 52 | 2.2% | |
| Witbier | 51 | 2.1% | |
| Other values (89) | 1051 | 43.6% |
Length
| Max length | 35 |
|---|---|
| Median length | 18 |
| Mean length | 17.2407638 |
| Min length | 3 |
table
Real number (ℝ≥0)
| Distinct count | 45 |
|---|---|
| Unique (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57.58588625985886 |
|---|---|
| Minimum | 51.0 |
| Maximum | 70.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 51 |
|---|---|
| 5-th percentile | 54 |
| Q1 | 56 |
| median | 57 |
| Q3 | 59 |
| 95-th percentile | 62 |
| Maximum | 70 |
| Range | 19 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.363736636 |
|---|---|
| Coefficient of variation (CV) | 0.04104715217 |
| Kurtosis | 1.903035993 |
| Mean | 57.58588626 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.9410429347 |
| Sum | 138724.4 |
| Variance | 5.587250886 |
| Value | Count | Frequency (%) | |
| 57 | 463 | 19.2% | |
| 56 | 431 | 17.9% | |
| 58 | 358 | 14.9% | |
| 59 | 279 | 11.6% | |
| 55 | 264 | 11.0% | |
| 60 | 205 | 8.5% | |
| 54 | 106 | 4.4% | |
| 61 | 101 | 4.2% | |
| 62 | 66 | 2.7% | |
| 63 | 35 | 1.5% | |
| Other values (35) | 101 | 4.2% |
| Value | Count | Frequency (%) | |
| 51 | 1 | < 0.1% | |
| 52 | 3 | 0.1% | |
| 53 | 25 | 1.0% | |
| 53.6 | 2 | 0.1% | |
| 53.7 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 70 | 2 | 0.1% | |
| 69 | 2 | 0.1% | |
| 68 | 1 | < 0.1% | |
| 67 | 7 | 0.3% | |
| 66 | 9 | 0.4% |
| Distinct count | 2409 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1205.0 |
|---|---|
| Minimum | 1 |
| Maximum | 2409 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 121.4 |
| Q1 | 603 |
| median | 1205 |
| Q3 | 1807 |
| 95-th percentile | 2288.6 |
| Maximum | 2409 |
| Range | 2408 |
| Interquartile range (IQR) | 1204 |
Descriptive statistics
| Standard deviation | 695.5627218 |
|---|---|
| Coefficient of variation (CV) | 0.5772304745 |
| Kurtosis | -1.2 |
| Mean | 1205 |
| Median Absolute Deviation (MAD) | 602 |
| Skewness | 0 |
| Sum | 2902845 |
| Variance | 483807.5 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 1256 | 1 | < 0.1% | |
| 1252 | 1 | < 0.1% | |
| 1250 | 1 | < 0.1% | |
| 1248 | 1 | < 0.1% | |
| 1246 | 1 | < 0.1% | |
| 1244 | 1 | < 0.1% | |
| 1242 | 1 | < 0.1% | |
| 1240 | 1 | < 0.1% | |
| 1238 | 1 | < 0.1% | |
| Other values (2399) | 2399 | 99.6% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2409 | 1 | < 0.1% | |
| 2408 | 1 | < 0.1% | |
| 2407 | 1 | < 0.1% | |
| 2406 | 1 | < 0.1% | |
| 2405 | 1 | < 0.1% |
x
Real number (ℝ≥0)
| Distinct count | 245 |
|---|---|
| Unique (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.683864674138647 |
|---|---|
| Minimum | 3.79 |
| Maximum | 7.53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 3.79 |
|---|---|
| 5-th percentile | 4.33 |
| Q1 | 5.67 |
| median | 5.79 |
| Q3 | 5.98 |
| 95-th percentile | 6.386 |
| Maximum | 7.53 |
| Range | 3.74 |
| Interquartile range (IQR) | 0.31 |
Descriptive statistics
| Standard deviation | 0.5870836051 |
|---|---|
| Coefficient of variation (CV) | 0.1032895114 |
| Kurtosis | 1.81348931 |
| Mean | 5.683864674 |
| Median Absolute Deviation (MAD) | 0.15 |
| Skewness | -1.406857999 |
| Sum | 13692.43 |
| Variance | 0.3446671594 |
| Value | Count | Frequency (%) | |
| 5.73 | 61 | 2.5% | |
| 5.7 | 54 | 2.2% | |
| 5.69 | 52 | 2.2% | |
| 5.74 | 51 | 2.1% | |
| 5.71 | 51 | 2.1% | |
| 5.76 | 51 | 2.1% | |
| 5.79 | 51 | 2.1% | |
| 5.8 | 50 | 2.1% | |
| 5.75 | 48 | 2.0% | |
| 5.72 | 47 | 2.0% | |
| Other values (235) | 1893 | 78.6% |
| Value | Count | Frequency (%) | |
| 3.79 | 1 | < 0.1% | |
| 3.83 | 1 | < 0.1% | |
| 3.85 | 1 | < 0.1% | |
| 3.87 | 1 | < 0.1% | |
| 3.88 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7.53 | 2 | 0.1% | |
| 7.26 | 1 | < 0.1% | |
| 7.12 | 1 | < 0.1% | |
| 7.01 | 1 | < 0.1% | |
| 6.99 | 1 | < 0.1% |
y
Real number (ℝ≥0)
| Distinct count | 244 |
|---|---|
| Unique (%) | 10.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.683416355334163 |
|---|---|
| Minimum | 3.75 |
| Maximum | 7.42 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 3.75 |
|---|---|
| 5-th percentile | 4.34 |
| Q1 | 5.68 |
| median | 5.8 |
| Q3 | 5.97 |
| 95-th percentile | 6.33 |
| Maximum | 7.42 |
| Range | 3.67 |
| Interquartile range (IQR) | 0.29 |
Descriptive statistics
| Standard deviation | 0.5753570982 |
|---|---|
| Coefficient of variation (CV) | 0.1012343742 |
| Kurtosis | 1.931271285 |
| Mean | 5.683416355 |
| Median Absolute Deviation (MAD) | 0.15 |
| Skewness | -1.49531877 |
| Sum | 13691.35 |
| Variance | 0.3310357904 |
| Value | Count | Frequency (%) | |
| 5.75 | 70 | 2.9% | |
| 5.73 | 62 | 2.6% | |
| 5.76 | 57 | 2.4% | |
| 5.7 | 56 | 2.3% | |
| 5.74 | 52 | 2.2% | |
| 5.72 | 52 | 2.2% | |
| 5.77 | 50 | 2.1% | |
| 5.81 | 50 | 2.1% | |
| 5.8 | 46 | 1.9% | |
| 5.85 | 45 | 1.9% | |
| Other values (234) | 1869 | 77.6% |
| Value | Count | Frequency (%) | |
| 3.75 | 1 | < 0.1% | |
| 3.78 | 1 | < 0.1% | |
| 3.84 | 2 | 0.1% | |
| 3.85 | 1 | < 0.1% | |
| 3.88 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7.42 | 2 | 0.1% | |
| 7.09 | 1 | < 0.1% | |
| 7.05 | 1 | < 0.1% | |
| 6.95 | 1 | < 0.1% | |
| 6.92 | 1 | < 0.1% |
z
Real number (ℝ≥0)
| Distinct count | 176 |
|---|---|
| Unique (%) | 7.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5101909506019093 |
|---|---|
| Minimum | 0.0 |
| Maximum | 4.78 |
| Zeros | 2 |
| Zeros (%) | 0.1% |
| Memory size | 18.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.68 |
| Q1 | 3.49 |
| median | 3.57 |
| Q3 | 3.7 |
| 95-th percentile | 3.986 |
| Maximum | 4.78 |
| Range | 4.78 |
| Interquartile range (IQR) | 0.21 |
Descriptive statistics
| Standard deviation | 0.3833005553 |
|---|---|
| Coefficient of variation (CV) | 0.1091964969 |
| Kurtosis | 6.831866423 |
| Mean | 3.510190951 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | -1.755561391 |
| Sum | 8456.05 |
| Variance | 0.1469193157 |
| Value | Count | Frequency (%) | |
| 3.54 | 96 | 4.0% | |
| 3.56 | 91 | 3.8% | |
| 3.53 | 86 | 3.6% | |
| 3.55 | 86 | 3.6% | |
| 3.57 | 86 | 3.6% | |
| 3.58 | 83 | 3.4% | |
| 3.52 | 77 | 3.2% | |
| 3.59 | 70 | 2.9% | |
| 3.51 | 55 | 2.3% | |
| 3.6 | 54 | 2.2% | |
| Other values (166) | 1625 | 67.5% |
| Value | Count | Frequency (%) | |
| 0 | 2 | 0.1% | |
| 2.27 | 1 | < 0.1% | |
| 2.31 | 3 | 0.1% | |
| 2.33 | 1 | < 0.1% | |
| 2.37 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4.78 | 1 | < 0.1% | |
| 4.7 | 1 | < 0.1% | |
| 4.42 | 1 | < 0.1% | |
| 4.38 | 1 | < 0.1% | |
| 4.34 | 1 | < 0.1% |
First rows
| Unnamed: 0 | carat | cut | color | clarity | depth | table | price | x | y | z | abv | ibu | id | name | style | brewery_id | ounces | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 0.23 | Ideal | E | SI2 | 61.5 | 55.0 | 326 | 3.95 | 3.98 | 2.43 | 0.066 | NaN | 2265 | Devil's Cup | American Pale Ale (APA) | 177 | 12.0 |
| 1 | 2 | 0.21 | Premium | E | SI1 | 59.8 | 61.0 | 326 | 3.89 | 3.84 | 2.31 | 0.071 | NaN | 2264 | Rise of the Phoenix | American IPA | 177 | 12.0 |
| 2 | 3 | 0.23 | Good | E | VS1 | 56.9 | 65.0 | 327 | 4.05 | 4.07 | 2.31 | 0.090 | NaN | 2263 | Sinister | American Double / Imperial IPA | 177 | 12.0 |
| 3 | 4 | 0.29 | Premium | I | VS2 | 62.4 | 58.0 | 334 | 4.20 | 4.23 | 2.63 | 0.075 | NaN | 2262 | Sex and Candy | American IPA | 177 | 12.0 |
| 4 | 5 | 0.31 | Good | J | SI2 | 63.3 | 58.0 | 335 | 4.34 | 4.35 | 2.75 | 0.077 | NaN | 2261 | Black Exodus | Oatmeal Stout | 177 | 12.0 |
| 5 | 6 | 0.24 | Very Good | J | VVS2 | 62.8 | 57.0 | 336 | 3.94 | 3.96 | 2.48 | 0.045 | NaN | 2260 | Lake Street Express | American Pale Ale (APA) | 177 | 12.0 |
| 6 | 7 | 0.24 | Very Good | I | VVS1 | 62.3 | 57.0 | 336 | 3.95 | 3.98 | 2.47 | 0.065 | NaN | 2259 | Foreman | American Porter | 177 | 12.0 |
| 7 | 8 | 0.26 | Very Good | H | SI1 | 61.9 | 55.0 | 337 | 4.07 | 4.11 | 2.53 | 0.055 | NaN | 2258 | Jade | American Pale Ale (APA) | 177 | 12.0 |
| 8 | 9 | 0.22 | Fair | E | VS2 | 65.1 | 61.0 | 337 | 3.87 | 3.78 | 2.49 | 0.086 | NaN | 2131 | Cone Crusher | American Double / Imperial IPA | 177 | 12.0 |
| 9 | 10 | 0.23 | Very Good | H | VS1 | 59.4 | 61.0 | 338 | 4.00 | 4.05 | 2.39 | 0.072 | NaN | 2099 | Sophomoric Saison | Saison / Farmhouse Ale | 177 | 12.0 |
Last rows
| Unnamed: 0 | carat | cut | color | clarity | depth | table | price | x | y | z | abv | ibu | id | name | style | brewery_id | ounces | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2399 | 2400 | 0.31 | Ideal | G | VS2 | 61.7 | 55.0 | 562 | 4.37 | 4.39 | 2.70 | 0.060 | 50.0 | 1511 | Worthy Pale | American Pale Ale (APA) | 199 | 12.0 |
| 2400 | 2401 | 0.70 | Ideal | E | VS2 | 61.1 | 56.0 | 3176 | 5.73 | 5.76 | 3.51 | 0.042 | NaN | 1345 | Patty's Chile Beer | Chile Beer | 424 | 12.0 |
| 2401 | 2402 | 0.72 | Ideal | D | SI2 | 60.5 | 57.0 | 3176 | 5.82 | 5.89 | 3.54 | 0.082 | NaN | 1316 | Colorojo Imperial Red Ale | American Strong Ale | 424 | 12.0 |
| 2402 | 2403 | 0.70 | Very Good | E | VS1 | 63.8 | 57.0 | 3177 | 5.61 | 5.65 | 3.59 | 0.055 | NaN | 1045 | Wynkoop Pumpkin Ale | Pumpkin Ale | 424 | 12.0 |
| 2403 | 2404 | 0.74 | Ideal | D | VS2 | 61.1 | 54.0 | 3177 | 5.86 | 5.89 | 3.59 | 0.075 | NaN | 1035 | Rocky Mountain Oyster Stout | American Stout | 424 | 12.0 |
| 2404 | 2405 | 0.67 | Very Good | G | VVS1 | 62.0 | 56.0 | 3178 | 5.60 | 5.62 | 3.48 | 0.067 | 45.0 | 928 | Belgorado | Belgian IPA | 424 | 12.0 |
| 2405 | 2406 | 0.74 | Ideal | H | VS2 | 62.2 | 55.0 | 3178 | 5.83 | 5.81 | 3.62 | 0.052 | NaN | 807 | Rail Yard Ale | American Amber / Red Ale | 424 | 12.0 |
| 2406 | 2407 | 0.72 | Ideal | G | VVS2 | 62.6 | 56.0 | 3179 | 5.70 | 5.74 | 3.58 | 0.055 | NaN | 620 | B3K Black Lager | Schwarzbier | 424 | 12.0 |
| 2407 | 2408 | 0.72 | Ideal | D | VS2 | 60.8 | 56.0 | 3179 | 5.80 | 5.84 | 3.54 | 0.055 | 40.0 | 145 | Silverback Pale Ale | American Pale Ale (APA) | 424 | 12.0 |
| 2408 | 2409 | 0.72 | Ideal | D | VS2 | 62.1 | 57.0 | 3179 | 5.69 | 5.75 | 3.55 | 0.052 | NaN | 84 | Rail Yard Ale (2009) | American Amber / Red Ale | 424 | 12.0 |